﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Text;

namespace WebAssistant.BusinessLogic.Model
{
    [SugarTable("companies")]
    public class Companies
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnName = "id")]
        public int Id { get; set; }

        /// <summary>
        /// 公司Id
        /// </summary>
        [SugarColumn(ColumnName = "company_id")]
        public int CompanyId { get; set; }

        /// <summary>
        /// 公司名称
        /// </summary>
        [SugarColumn(ColumnName = "name")]
        public string Name { get; set; }

        /// <summary>
        /// 排序
        /// </summary>
        [SugarColumn(ColumnName = "sequence", IsNullable = true)]
        public int Sequence { get; set; }

        /// <summary>
        /// 公司标语
        /// </summary>
        [SugarColumn(ColumnName = "report_header", IsNullable = true)]
        public string ReportHeader { get; set; }

        /// <summary>
        /// 报表页脚
        /// </summary>
        [SugarColumn(ColumnName = "report_footer", IsNullable = true)]
        public string ReportFooter { get; set; }

        /// <summary>
        /// 纸张格式
        /// </summary>
        [SugarColumn(ColumnName = "paperformat_id")]
        public long? PaperformatId { get; set; }

        /// <summary>
        /// 公司LOGO
        /// </summary>
        [SugarColumn(ColumnName = "logo")]
        public string Logo { get; set; }

        /// <summary>
        /// 公司图标
        /// </summary>
        [SugarColumn(ColumnName = "favicon", IsNullable = true)]
        public string Favicon { get; set; }

        /// <summary>
        /// 电子邮件
        /// </summary>
        [SugarColumn(ColumnName = "email", IsNullable = true)]
        public string Email { get; set; }

        /// <summary>
        /// 电话
        /// </summary>
        [SugarColumn(ColumnName = "phone", IsNullable = true)]
        public string Phone { get; set; }

        /// <summary>
        /// 公司注册号
        /// </summary>
        [SugarColumn(ColumnName = "company_registry", IsNullable = true)]
        public string CompanyRegistry { get; set; }

        /// <summary>
        /// 税号
        /// </summary>
        [SugarColumn(ColumnName = "vat", IsNullable = true)]
        public string Vat { get; set; }

        /// <summary>
        /// 网站
        /// </summary>
        [SugarColumn(ColumnName = "website", IsNullable = true)]
        public string Website { get; set; }



        /// <summary>
        /// 街道
        /// </summary>
        [SugarColumn(ColumnName = "street", IsNullable = true)]
        public string Street { get; set; }

        /// <summary>
        /// 街道
        /// </summary>
        [SugarColumn(ColumnName = "street2", IsNullable = true)]
        public string Street2 { get; set; }

        /// <summary>
        /// 街道名称
        /// </summary>
        [SugarColumn(ColumnName = "street_name", IsNullable = true)]
        public string StreetName { get; set; }

        /// <summary>
        /// 楼号
        /// </summary>
        [SugarColumn(ColumnName = "street_number", IsNullable = true)]
        public string StreetNumber { get; set; }

        /// <summary>
        /// 门牌号
        /// </summary>
        [SugarColumn(ColumnName = "street_number2", IsNullable = true)]
        public string StreetNumber2 { get; set; }

        /// <summary>
        /// 国家/地区
        /// </summary>
        [SugarColumn(ColumnName = "country_id", IsNullable = true)]
        public int CountryId { get; set; }

        /// <summary>
        /// 省/州
        /// </summary>
        [SugarColumn(ColumnName = "state_id", IsNullable = true)]
        public int StateId { get; set; }

        /// <summary>
        /// 城市
        /// </summary>
        [SugarColumn(ColumnName = "city", IsNullable = true)]
        public string City { get; set; }

        /// <summary>
        /// 邮政编码
        /// </summary>
        [SugarColumn(ColumnName = "zip", IsNullable = true)]
        public string Zip { get; set; }
    }
}
